GeophysicalLocationCoordinate

Entity Definition

Logical Name : GeophysicalLocationCoordinate
Physical Name : LO_CRDN_GEO_LCN

The geo-physical co-ordinates that identify a GeoPhysicalLocation. This is expressed as longitude, latitude and altitude.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
GeophysicalLocationCoordinateID (PK) Token identifier for a POINT location (a longitude, latitude, altitude coordinate). ID_GEO_LCN_CRDN Identity integer
GeophysicalCoordinateSystemTypeCode (AK)(FK) A retailer assigned mnemonic code denoting the geo-physical co-ordinate system. CD_TYP_CRDN_GEO Code2 char(2) GeophysicalCoordinateSystem(LO_CRDN_TYP)
CoOrdinateValue (AK) A string containing the Co-Ordinate, the format of which is defined by the GeoPhysicalCoOrdinateSystem. Eg: ISO-6709 defines a standardised representation of Latitude, Longitude & Altitude: �DDMMSS.SS�DDDMMSS.SS�AAAA.AA/ where: � = direction identitier DD & DDD = Degrees of latitude & longitude MM = Minutes of latitude & longitude SS.SS = Seconds of latitude & longitude AAAA.AA = metres of altitude / = terminator So the summit of Mt Everest is represented by +27.5916+086.5640+8850/ CD_CRDN_VL ISO-6709LongitudeLatitude varchar(30)
LongitudeDegrees Longitude is a geographic coordinate that specifies the east-west position of a point on the Earth's surface. Degree is a unit of measure that appear as vertical lines that organize the Earth into 360 equal segments. DGR_LNGTD DegreeLongitude integer
LongitudeMinutes Longitude is a geographic coordinate that specifies the east-west position of a point on the Earth's surface. Minute is a unit of measure that appear as vertical lines that organize each degree into 60 equal segments. MI_LNGTD MinuteSecond integer
LongitudeSeconds Longitude is a geographic coordinate that specifies the east-west position of a point on the Earth's surface. Minute is a unit of measure that appear as vertical lines that organize each minute into 60 equal segments. SI_LNGTD MinuteSecond integer
LongitudeDirectionCode One of two values indicating corrdinate direction relative to the PRIME Meridian + = EAST of the PRIME Meridian - = WEST of the PRIME Meridian CD_LNGTD_DIR Code char(1)
LatitudeDegrees In geography, latitude (f) is a geographic coordinate that specifies the north-south position of a point on the Earth's surface. Degree organizes northern half of the Earth into 90 segments numberd as positive values and the sourthern half of the Earth into 90 segments numbered as negative values. DGR_LTTD DegreeLatitude integer
LatitudeMinutes In geography, latitude (f) is a geographic coordinate that specifies the north-south position of a point on the Earth's surface. Minute organizes a degree into 60 equal segments MI_LTTD MinuteSecond integer
LatitudeSeconds In geography, latitude (f) is a geographic coordinate that specifies the north-south position of a point on the Earth's surface. Second organizes a minute into 60 equal segments SI_LTTD MinuteSecond integer
LatitudeDirectionCode One of two values indicating corrdinate direction relative to the EQUATOR One of two signs + = north of the equator - = south of the equator CD_LTTD_DRC Code char(1)
AltitudeMeters Altitude measured in meters. A positive value is an altitude above sea level (0 meters). A negative value is altitude below sea level (e.g. Death Valley or the Dead Sea) QU_ALTTD_MTR Quantity integer

Relationships

Parent Entity Verb Phrase Child Entity
GeophysicalCoordinateSystem defines GeophysicalLocationCoordinate
GeophysicalLocationCoordinate defines location for METARweatherSite
GeophysicalLocationCoordinate defines coordinates of GeophysicalLocation

Logical Views containing GeophysicalLocationCoordinate

Logical View
Logical 05100 - Taxation - Rules View
Logical 07030 - Customer Segment Independent Characteristics
Logical 10100 - Enterprise - Locations Macro View
Logical 10102 - EnterpriseWeather
Logical 10108 - Enterprise - Physical Locations View
Logical 10108 - Enterprise - Physical Locations View